﻿/*   
    Copyright (C) 2009 Galaktika Corporation ZAO

    This file is a part of Galaktika.BusinessMonitor
 
    Galaktika.BusinessMonitor is a free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.
      
    You should have received a copy of the GNU General Public License
    along with Galaktika.BusinessMonitor.  If not, see <http://www.gnu.org/licenses/>.
  
    If GPL v.3 is not suitable for your products or company,
    Galaktika Corp provides Galaktika.BusinessMonitor under a flexible commercial license
    designed to meet your specific usage and distribution requirements.
    If you have already obtained a commercial license from Galaktika Corp,
    you can use this file under those license terms.
*/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Galaktika.BI.Silverlight.Services;
using Galaktika.BI.Silverlight.Commands;
using Galaktika.BI.Silverlight.ClientApp.Web.Runtime.DataAccess;
//using Ranet.Olap.Core.Compressor;
using System.Configuration;
using Ranet.ZipLib;

namespace Galaktika.BI.Silverlight.ClientApp.Web.Commands
{
    public class ExecuteQueryCommand2 : ServerCommand
    {
        bool UseCompress = true;
        public ExecuteQueryCommand2(InvokeSchema invoker)
            : base(CommandId.GetDataCommandId)
        {
            if (ConfigurationSettings.AppSettings.AllKeys.Contains("CompressData"))
            {
                String str = ConfigurationSettings.AppSettings["CompressData"];
                try
                {
                    if (!String.IsNullOrEmpty(str))
                        UseCompress = Convert.ToBoolean(str);
                }
                catch (System.FormatException)
                {
                }
            }
            this.Schema = invoker;
        }

        public InvokeSchema Schema { get; private set; }

        public override InvokeResultSchema Invoke()
        {
            InvokeSchema invoker = this.Schema;
            var connectionString = invoker[KnownInvokeArgs.ConnectionString];
            var query = invoker[KnownInvokeArgs.Query];
            var sessionId = invoker[KnownInvokeArgs.SessionId];
            var connectionType = invoker[KnownInvokeArgs.ConnectionType];
            var queryId = invoker[KnownInvokeArgs.QueryId];

            InvokeResultSchema res = null;
            var queryExecutor = QueryExecutorFactory.Create(connectionType);
            if (string.IsNullOrEmpty(invoker[KnownInvokeArgs.NonQuery]))
            {
                res = QueryManager.Current.ExecuteQuery(
                    queryId,
                    () => queryExecutor.ExecuteQuery(connectionString, query, sessionId),
                    () => true,
                    () => queryExecutor.Cancel()); 
            }
            else
            {
                res = QueryManager.Current.ExecuteQuery(
                    queryId,
                    () => queryExecutor.ExecuteNonQuery(connectionString, query, sessionId),
                    () => true,
                    () => queryExecutor.Cancel());
            }

            if (UseCompress && res.ContentType != KnownContentTypes.Error && res.ContentType != KnownContentTypes.ADOMDError)
            {
                // Архивация строки
                String compesed = ZipCompressor.CompressAndConvertToBase64String(res.Content);
                res.Content = compesed;
                res.IsArchive = true;
            }
            return res;
        }
    }
}
